package com.itic.mall.system.goods.goodssku.persistence.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.itic.appbase.framework.common.annotation.IticDBDao;
import com.itic.appbase.framework.common.persistence.dao.CrudDao;
import com.itic.mall.system.goods.goodssku.persistence.basedao.GoodsSkuMapper;
import com.itic.mall.system.goods.goodssku.persistence.model.GoodsSku;
import com.itic.mall.system.goods.goodssku.persistence.model.GoodsSkuExample;


@IticDBDao
public interface GoodsSkuDao
     extends GoodsSkuMapper,CrudDao<GoodsSku,GoodsSkuExample> {

	Integer getTotalSalesBySpuId(String id);
	
	Integer getTotalInventoryBySkuIdAndcount(String id);
	
	List<GoodsSku> getGoodsSkuByParmquery(String ParmQuery);
	
	List<GoodsSku> getGoodsSkuBySpuId(String spuId);
	
	GoodsSku getGoodsSkuBySpuIdPropertyId(@Param("spuId") String spuId, @Param("propertyId") String propertyId);
	
	GoodsSku getSkuByskuNum(String skuNum);
	
	boolean deleteBySpuId(String spuId);
}